Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
FuelingTransactionID (FK) | A unique identifier for the fuelling transaction | ID_TRN_FUEL | Identity | integer | FuelingTransaction(EV_TR_FUEL) |
VehicleColor | The color of the vehicle that did the drive-off | NM_CLR_VH | Name | varchar(40) | |
VehicleManufacturer | The make of the vehicle that did the drive-off | NM_MF_VH | Name | varchar(40) | |
VehicleModel | The model of the vehicle that did the drive-off | NM_MDL_VH | Name | varchar(40) | |
VehicleRegistrationNumber | The registration nujmber of the vehicle that did the drive-off | NM_RGST_VH | Name | varchar(40) | |